How to select comma separated list in Sqlserver

Question

Anonymous User · Answer

When we wantand  to generate a comma separated list of columns values like a list of EmailIDs to send mail. In SQL Server, we can make a comma separated list by using COALESCE as shown in below.Use of COALESCE to create comma separated listSuppose we have following data in Employee table and we need to make a semicolon separated list of EmailIDs to send mail, then we can use COALESCE as shown in below.declare @strEmailid Varchar(max);select @strEmailid=COALESCE(@strEmailid+',','')+ EmailID FROM EmployeePRINT @strEmailid

forum

How to select comma separated list in Sqlserver

Anonymous User

Can you answer this question?

1 Answers

Liked By